create database temp_ms;

CREATE TABLE states(
  state_code character(3),
   state_name character(100),
   lgd_code character(3),
     PRIMARY KEY(state_code)
);

INSERT INTO states (state_code, state_name, lgd_code) VALUES 
('36','TELANGANA','TS'), ('37','LADAKH','LD'), ('28','SIKKIM','SK'), ('06','DemoStateCHANDIGARH','DEM'), ('26','PUNJAB','PB'), ('03','ARUNACHAL PRADESH','AR'), ('12','HARYANA','HR'), ('11','GUJARAT','GJ'), ('35','UTTARAKHAND','UT'), ('13','HIMACHAL PRADESH','HP'), ('04','ASSAM','AS'), ('05','BIHAR','BH'), ('10','GOA','GO'), ('34','JHARKHAND','JH'), ('33','CHHATTISGARH','CH'), ('15','KARNATAKA','KN'), ('14','JAMMU AND KASHMIR','JK'), ('16','KERALA','KL'), ('18','MAHARASHTRA','MH'), ('27','RAJASTHAN','RJ'), ('29','TAMIL NADU','TN'), ('24','ODISHA','OR'), ('30','TRIPURA','TR'), ('31','UTTAR PRADESH','UP'), ('32','WEST BENGAL','WB'), ('01','ANDAMAN AND NICOBAR','AN'), ('07','DN HAVELI AND DD','DN'), ('19','LAKSHADWEEP','LK'), ('20','MANIPUR','MN'), ('23','NAGALAND','NL'), ('25','PUDUCHERRY','PC'), ('17','MADHYA PRADESH','MP'), ('02','ANDHRA PRADESH','AP'), ('22','MIZORAM','MZ'), ('21','MEGHALAYA','MG');